package vell.velllock.database;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

public class WordDBInfoOpenHelper extends SQLiteOpenHelper {

	public WordDBInfoOpenHelper(Context context) {
		super(context, "WordDBInfo.db", null, 3);
	}

	@Override
	public void onCreate(SQLiteDatabase db) {
		db.execSQL("create table if not exists [WordDBInfo] (" +
			  "[id] INTEGER PRIMARY KEY AUTOINCREMENT, " +
			  "[DBName] TEXT NOT NULL, " +
			  "[info] TEXT, " +
			  "[wordNum] INT DEFAULT 0, " +
			  "[DBFile] TEXT NOT NULL, " +
			  "[active] INT DEFAULT 0)");
	}

	@Override
	public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
		onCreate(db);
	}
	
}
